package com.eight.travel.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.eight.travel.pojo.StorePic;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

import java.util.List;

public interface StorePicMapper extends BaseMapper<StorePic> {

    //查询总条数（用于分页查询）
    @Select("select count(*) from storepic where storepic.sid=#{sid}")
    int selectBySidRow(Integer sid);

    @Select("select * from storepic where sid=#{sid}")
    List<StorePic> selectBySid(Integer sid);
}
